﻿CREATE TABLE DBBackOffice.DBOrderStatus (
	ID				uniqueidentifier PRIMARY KEY,							/* Unique GUID for this status change */
	DBOrderID		uniqueidentifier NOT NULL,								/* Status changed, and this is related to this order */
	Status			varchar(16) NOT NULL, 									/* This is the new status */
	TimeStamp		datetime2 NOT NULL,										/* Occured at this time */
	
    FOREIGN KEY (DBOrderID) REFERENCES DBBackOffice.DBOrder(ID) ON DELETE CASCADE,
);
